commands/management/commands/sale.py

@@ -7,7 +7,7 @@ from django_six import CompatibilityBaseCommand, close_old_connections

                 from TimeConvert import TimeConvert as tc
              

                 
              

                 from integral.models import SaleclerkSubmitLogInfo
              

                -from mch.models import BrandInfo, DistributorInfo, ModelInfo
              

                +from mch.models import BrandInfo, DistributorInfo, ModelInfo, SaleclerkInfo
              

                 from sales.models import SalesResponsibilityInfo, SalesResponsibilityInfoModelsSaleStatisticInfo, SuperSalesResponsibilityInfoModelsSaleStatisticInfo
              

                 
              

                 
              
@@ -37,13 +37,20 @@ class Command(CompatibilityBaseCommand):

                 
              

                             distributors = DistributorInfo.objects.filter(brand_id=b.brand_id, status=True)
              

                             models = ModelInfo.objects.filter(brand_id=b.brand_id, status=True)
              

                -            for d in distributors:
              

                -                for m in models:
              

                -                    logs = SaleclerkSubmitLogInfo.objects.filter(distributor_pk=d.pk, model_pk=m.pk, dupload=False, test_sn=False, status=True)
              

                -                    # today_num = logs.filter(ymd=day).count()
              

                -                    yesterday_num = logs.filter(ymd=lastday).count()
              

                -                    current_month = logs.filter(ym=month).count()
              

                -                    last_month = logs.filter(ym=lastmonth).count()
              

                +            for m in models:
              

                +                logs = SaleclerkSubmitLogInfo.objects.filter(model_pk=m.pk, dupload=False, test_sn=False, ym__gte=lastmonth, status=True)
              

                +                for d in distributors:
              

                +                    yesterday_num = 0
              

                +                    current_month = 0
              

                +                    last_month = 0
              

                +                    if logs.count() != 0:
              

                +                        saleclerks = SaleclerkInfo.objects.filter(brand_id=b.brand_id, distributor_id=d.distributor_id, status=True)
              

                +                        for saleclerk in saleclerks:
              

                +                            log = logs.filter(clerk_id=saleclerk.clerk_id)
              

                +                            yesterday_num += log.filter(ymd=lastday).count()
              

                +                            current_month += log.filter(ym=month).count()
              

                +                            last_month += log.filter(ym=lastmonth).count()
              

                +
              

                                     if m.is_important or (yesterday_num or current_month or last_month):
              

                                         SalesResponsibilityInfoModelsSaleStatisticInfo.objects.create(
              

                                             brand_id=b.brand_id,
              
@@ -61,7 +68,6 @@ class Command(CompatibilityBaseCommand):

                 
              

                             srs = SalesResponsibilityInfo.objects.filter(brand_id=b.brand_id, status=True)
              

                             for s in srs:
              

                -                print s
              

                                 if s.is_super:
              

                                     continue
              

                                 sums = SalesResponsibilityInfoModelsSaleStatisticInfo.objects.filter(